﻿CREATE PROCEDURE state_Loan_CheckVerification
	@LoanID int
AS
SET NOCOUNT ON

DECLARE @VID int
SELECT @VID = ID FROM t_VerificationSmart WHERE LoanID = @LoanID

EXEC state_Verify_CheckApproved @VID

